SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create Procedure [dbo].[spXoaNVTheoLoaiNV]
@maloai int
As
Begin
Delete from NhanVien
	where MaLoaiNV = @maloai	
Delete From LoaiNhanVien
	Where MaLoaiNV = @maloai
End